Syntax:
LastDayOfQuarter(dateexpr)
Description:
Returns the last day (i.e. Sunday, Monday, etc.) of the quarter specified
by dateexpr. For
example, this function could return the name of last day of second quarter
of the current year. A
quarter occurs every three months starting in January. The
return integer is one of the following:
ò vbSunday (1) - Sunday
ò vbMonday (2) - Monday
ò vbTuesday (3) - Tuesday
ò vbWednesday (4) - Wednesday
ò vbThursday (5) - Thursday
ò vbFriday (6) - Friday
ò vbSaturday (7) - Saturday
Parameter Description
dateexpr A date which contains the quarter to be examined
Example:
Sub
Main
'return the name of the last day of this quarter
lastDayOfThisQuarter = LastDayOfQuarter (Now())
End Sub
See Also